Join Dataframes / CSV



In [3]:

    
import pandas as pd



In [4]:

    
a = pd.read_csv('./Screening.CSV')
a.set_index('Sample ID');

b = pd.read_csv('./fp.csv')
b.set_index('Sample ID');

out = pd.merge(a, b)
out.set_index('Sample ID')
out.to_csv('T-series.csv')

Analysis



In [7]:

    
# Select onlly chips with no Yb
out[out['Yb'] == -1]









    Out[7]:






  
    
      
      Sample ID
      StdOrder
      RunOrder
      CenterPt
      Blocks
      Er
      Yb
      Deposition Time
      Pressure
      Lifetime_100us_pump
      Reflection (%)
      Transmission (%)
      n
      d
      WG Modes Air
      WG Modes Canola
      Purcell Factor
    
  
  
    
      0
      T2
      5
      1
      1
      1
      -1
      -1
      1
      1
      12.478841
      0.173160
      92.644947
      1.5881
      1.0821
      2.0
      0.0
      0.937987
    
    
      2
      T5
      1
      3
      1
      1
      -1
      -1
      -1
      -1
      12.971973
      0.171110
      92.162333
      1.5801
      0.7351
      2.0
      0.0
      1.036182
    
    
      4
      T7
      2
      5
      1
      1
      1
      -1
      -1
      1
      10.870046
      0.138847
      93.050809
      1.6191
      0.4802
      2.0
      0.0
      1.100583
    
    
      8
      T14
      6
      9
      1
      1
      1
      -1
      1
      -1
      10.407751
      1.346310
      91.650510
      NaN
      NaN
      NaN
      NaN
      NaN
    
    
      12
      T21
      18
      13
      1
      2
      -1
      -1
      -1
      1
      12.251599
      4.614486
      91.920114
      1.6058
      1.1967
      2.0
      0.0
      0.915716
    
    
      15
      T24
      15
      16
      1
      2
      -1
      -1
      1
      -1
      12.323310
      0.588810
      92.363893
      1.6048
      2.3665
      4.0
      0.0
      0.931253
    
    
      17
      T26
      13
      18
      1
      2
      1
      -1
      1
      1
      11.792269
      0.126496
      91.972316
      1.6308
      2.0468
      4.0
      2.0
      1.045898
    
    
      18
      T27
      16
      19
      1
      2
      1
      -1
      -1
      -1
      10.847124
      11.094721
      91.921055
      1.6310
      1.7988
      4.0
      2.0
      1.026450



In [8]:

    
_.to_csv('Er-only.csv')



In [ ]:

	Sample ID	StdOrder	RunOrder	CenterPt	Blocks	Er	Yb	Deposition Time	Pressure	Lifetime_100us_pump	Reflection (%)	Transmission (%)	n	d	WG Modes Air	WG Modes Canola	Purcell Factor
0	T2	5	1	1	1	-1	-1	1	1	12.478841	0.173160	92.644947	1.5881	1.0821	2.0	0.0	0.937987
2	T5	1	3	1	1	-1	-1	-1	-1	12.971973	0.171110	92.162333	1.5801	0.7351	2.0	0.0	1.036182
4	T7	2	5	1	1	1	-1	-1	1	10.870046	0.138847	93.050809	1.6191	0.4802	2.0	0.0	1.100583
8	T14	6	9	1	1	1	-1	1	-1	10.407751	1.346310	91.650510	NaN	NaN	NaN	NaN	NaN
12	T21	18	13	1	2	-1	-1	-1	1	12.251599	4.614486	91.920114	1.6058	1.1967	2.0	0.0	0.915716
15	T24	15	16	1	2	-1	-1	1	-1	12.323310	0.588810	92.363893	1.6048	2.3665	4.0	0.0	0.931253
17	T26	13	18	1	2	1	-1	1	1	11.792269	0.126496	91.972316	1.6308	2.0468	4.0	2.0	1.045898
18	T27	16	19	1	2	1	-1	-1	-1	10.847124	11.094721	91.921055	1.6310	1.7988	4.0	2.0	1.026450